EMT Practice Test

1. Question Content...

---

Question1: Which of the following data elements would not normally be stored in binary format?

Question2: Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail.
Who had the highest score?

Question3: Kelly wants to get feedback on the final draft of a strategic report that has taken her six months to develop.
What can she do to get prevent confusion as see seeks feedback before publishing the report?
Choose the best answer.

Question4: Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

Question5: A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:

Question6: You would like to know whether the mean height of a group of children is statistically significantly different from that of another group.
What statistical test would be most appropriate?

Question7: Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.
In what phase are the group's R skills most relevant?

Question8: How many US. states currently have data breach notification laws?

Question9: A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO).
Which of the following should be included in the report?

Question10: What feature varies on a bubble chart but not on a scatter plot?

Question11: Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders.
Which one of the following tools is least likely to meet her needs?

Question12: A data analyst has been asked to derive a new variable labeled "Promotion_flag" based on the total quantity sold by each salesperson. Given the table below:

Which of the following functions would the analyst consider appropriate to flag "Yes" for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

Question13: What is the median of the following numbers?
13, 2, 65, 3, 5, 4, 7, 3, 4, 7, 8, 2, 4, 4, 60, 23, 43, 2

Question14: What's the minimum passing score on the Data+ exam?

Question15: Which of the following statistical methods requires two or more categorical variables?

Question16: An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

Question17: What type of regulation is the Payment Card Industry Data Security Standard (PCIDSS)?

Question18: Which of the following is used for calculations and pivot tables?

Question19: What type of report is commonly used to make operational decisions?

Question20: What symbol is used for the variance of a population of data?

Question21: What technique can you use to predict one value from another using a linear relationship?

Question22: Which one of the following programming languages is specifically designed for use in analytics applications?

Question23: An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

Question24: Zip code,____________, and___________ uniquely identify 87% of people in the United States.

Question25: Andy is a pricing analyst for a retailer. Using a hypothesis test, he wants to assess whether people who receive electronic coupons spend more on average.
What should Andy's null hypothesis be?

Question26: The sales grocery store had an average of $8000 per day. The store introduced several advertising campaigns in order to increase sales. To determine whether the advertising campaigns have been effective in increasing sales, a sample of 64 days of sales was selected, and the sample mean was $8000 per day.
The correct null and alternative hypotheses to test whether there has been a significant increase are

Question27: Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

Question28: Which one of the following in NOT a common data integration tool?

Question29: Which of the following is an example of a discrete data type?

Question30: What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

Question31: Which one of the following R values shows strongest positive correlation between two variables?

Question32: What European law requires that organizations handling personal information designate a Data Protection Officer (DPO)?

Question33: Encryption is a mechanism for protecting data.
When should encryption be applied to data?
Choose the best answer.

Question34: You are creating a dashboard that shows the total revenue for your organization broken out by a variety of factors. Which one of these is a measure, rather than a dimension?

Question35: A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to use?

Question36: Consider the following dataset which contains information about houses that are for sale:

Which of the following string manipulation commands will combine the address and region name columns to create a full address?
full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan

Question37: A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

Question38: You are working with a dataset and need to swap the values in rows with those in columns.
What action do you need to perform?

Question39: What role in a data governance is typically responsible for day-to-day oversight of data use?

Question40: An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?

Question41: Which of the following BEST describes standard deviation?

Question42: An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Question43: Analyze the values of X shown below
(2,2,5,6,7)
What is the modal value?

Question44: When would you show time on a standard line chart?

Question45: What output from a statistical test is used when performing hypothesis testing?

Question46: James wants to analyze profit based on sales of five different product categories.
His source data set consists of 5.8 million rows with columns including region, product category, product name, and sales price.
How should he manipulate the data to facilitate his analysis?
Choose the best answer.

Question47: Given the diagram below:

Which of the following data schemas shown?

Question48: When building a word cloud, what feature varies with the frequency that a word appears in the text?

Question49: The category PII (Personally identifiable information) includes all of the following, except_________.

Question50: What test formatting option indicates that a field is required in an entity relationship diagram?

Question51: Which dimension of data quality ensures that data stored in multiple locations is the same?

Question52: Which one the following is not considered an aggregate function?

Question53: Olivia has 15 people on her data analytics team. Her team's charter requires that all team members have read access to the finance, human resources, sales, and customer service areas of the corporate data warehouse.
What is the best way to provision access to her team?
Choose the best answer.

Question54: Which of the following entities would NOT be regulated by the Health Insurance Portability and Accountability Act (HIPAA)?

Question55: What is the most time-consuming of the practices that authorize international data transfers under GDPR?

Question56: A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

Question57: You would like to combine the text in two different strings to form a single string.
What action are you performing?

Question58: Melissa wants to explore central tendency in her dataset.
Which statistic best matches her need?

Question59: A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?

Question60: What cybersecurity goal protects an organization's data from unauthorized modification?

Question61: An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Question62: You are working with a professional statistician to perform an analysis and would like to use a statistics package.
Which one of the following would be the most appropriate?

Question63: An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?

Question64: You would like to measure how well an organization is achieving its goals.
What type of analysis should you perform?

Question65: Most data that exists in the world is structured data.

Question66: What type of access permission system is most appropriate for a dashboard?

Question67: An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

Question68: A data analyst wants to create "Income Categories" that would be calculated based on the existing variable "Income". The "Income Categories" would be as follows:
Income category 1: less than $1.
Income category 2: more than $1 and less than $20,000.
Income category 3: more than $20,001 and less than $40,000.
Income category 4: more than $40,001.
Which of the following data manipulation techniques should the data analyst use to create "Income Categories"?

Question69: In a tabular dataset, what term is used to describe the data that appears in a single row?

Question70: The number of phone calls that call center receives in a day is an example of:

Question71: An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst's goal?

Question72: Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table.
What type of design pattern is the data warehouse using?

Question73: When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1.
What term describes this action?

Question74: A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of: